CREATE VIEW [dbo].[vSoaInvoiceSummaryCashBase] WITH SCHEMABINDING
AS
SELECT
       CAST('CASH:' + [ID] AS VARCHAR(20)) AS InvoiceId,
       [ORG_CODE] AS FinancialEntityId,
       0 AS InvoiceNumber,
       [ID] AS BillToPartyId,
       [ID] AS SoldToPartyId

  FROM [dbo].[Name]

GO
CREATE UNIQUE CLUSTERED INDEX [PK_vSoaInvoiceSummaryCashBase] ON [dbo].[vSoaInvoiceSummaryCashBase] ([InvoiceId]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_vSoaInvoiceSummaryCashBase_BillToPartyId] ON [dbo].[vSoaInvoiceSummaryCashBase] ([BillToPartyId]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_vSoaInvoiceSummaryCashBase_InvoiceNumber] ON [dbo].[vSoaInvoiceSummaryCashBase] ([InvoiceNumber]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_vSoaInvoiceSummaryCashBase_SoldToPartyId] ON [dbo].[vSoaInvoiceSummaryCashBase] ([SoldToPartyId]) ON [PRIMARY]
GO